﻿CREATE proc sp_loadtigia   
@NgayCT as datetime,    
@TienTe as nvarchar(50)    
as    
select tygia from DM_tygia    
where rtrim(nt)=@TienTe and convert(char,year(@NgayCT)) =rtrim(nam)  
 and convert(char,month(@NgayCT))=rtrim(thang)